﻿CREATE VIEW [dbo].[ASMS_V_StaffPosition]
	AS 
SELECT SP.Post, SP.[Status],
	SP.StaffId,
	SP.StationId,
	S.Name as StaffName,
	S.Telephone as StaffTelephone,
	S.Pinyin as StaffPinyin,
	S.Letter as StaffLetter,
	S.BusinessId
FROM ASMS_StaffPosition as SP
inner join ASMS_Staff as S on S.Id = SP.StaffId
